function does not exist error...
| От | Dan Jewett |
|---|---|
| Тема | function does not exist error... |
| Дата | |
| Msg-id | p05200f02ba02df1d4182@[162.84.132.56] обсуждение исходный текст |
| Ответы |
Re: function does not exist error...
|
| Список | pgsql-novice |
Can someone help me figure out why my trigger can't meet my function?
Other than the obvious reason that I'm a total beginner, and I don't
know what the heck I'm doing. :-)
After I got the CreateTrigger error, I reran the CreateFunction query
just to see what would happen:
recordings=> CREATE FUNCTION check_participant(varchar) RETURNS opaque AS '
DECLARE name ALIAS FOR $1;
BEGIN
SELECT fname FROM participant WHERE fname = name; IF FOUND
THEN RETURN 0;
ELSE INSERT INTO artist (fname) VALUES (name); END IF; END;'
LANGUAGE 'plpgsql';
ERROR: function check_participant already exists with same argument types
recordings=> CREATE TRIGGER trigger_artist BEFORE INSERT ON participant
FOR EACH ROW EXECUTE PROCEDURE check_participant();
ERROR: CreateTrigger: function check_participant() does not exist
В списке pgsql-novice по дате отправления: